IF OBJECT_ID('ssf.log_info_incomplete') IS NOT NULL
	DROP VIEW ssf.log_info_incomplete
GO

CREATE VIEW ssf.log_info_incomplete
AS
SELECT log_id
	, source_object
	, task
	, task_description
	, target_object
	, log_sql
	, begin_spid
	, begin_login
	, begin_log_time
FROM ssf.log_info WITH (NOLOCK)
WHERE end_log_time IS NULL
GO
